<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.cmccsi.mapper.qxdomainDtoMapper" >
  <resultMap id="BaseResultMap" type="com.cmccsi.entity.qxdomainDto" >
    <id column="domain" property="domain" jdbcType="VARCHAR" />
    <result column="domain_name" property="domainName" jdbcType="VARCHAR" />
    <result column="logo" property="logo" jdbcType="VARCHAR" />
    <result column="product_name" property="productName" jdbcType="VARCHAR" />
    <result column="contact" property="contact" jdbcType="VARCHAR" />
    <result column="com_site" property="comSite" jdbcType="VARCHAR" />
    <result column="license" property="license" jdbcType="INTEGER" />
    <result column="paramvalue" property="paramvalue" jdbcType="VARCHAR" />
    <result column="paramname" property="paramname" jdbcType="VARCHAR" />
    <result column="corpinfovalue" property="corpinfovalue" jdbcType="VARCHAR" />
    <result column="corpinfoname" property="corpinfoname" jdbcType="VARCHAR" />
    <result column="pointname" property="pointname" jdbcType="VARCHAR" />
    <result column="pointvalue" property="pointvalue" jdbcType="VARCHAR" />
    <result column="status" property="status" jdbcType="VARCHAR" />
    <result column="urllist" property="urllist" jdbcType="VARCHAR" />
    <result column="eccode" property="eccode" jdbcType="VARCHAR" />
    <result column="cyloginflag" property="cyloginflag" jdbcType="INTEGER" />
  </resultMap>
  <resultMap id="ResultMapWithBLOBs" type="com.cmccsi.entity.qxdomainDto" extends="BaseResultMap" >
    <result column="com_describe" property="comDescribe" jdbcType="LONGVARCHAR" />
  </resultMap>
  <sql id="Base_Column_List" >
    domain, domain_name, logo, product_name, contact, com_site, license, paramvalue, 
    paramname, corpinfovalue, corpinfoname, pointname, pointvalue, status, urllist, eccode, 
    cyloginflag
  </sql>
  <sql id="Blob_Column_List" >
    com_describe
  </sql>
  <select id="selectByPrimaryKey" resultMap="ResultMapWithBLOBs" parameterType="java.lang.String" >
    select 
    <include refid="Base_Column_List" />
    ,
    <include refid="Blob_Column_List" />
    from qxdomain
    where domain = #{domain,jdbcType=VARCHAR}
  </select>
  
  <select id="selectByEcodeOrdomainName" resultMap="ResultMapWithBLOBs" >
    select 
    <include refid="Base_Column_List" />
    ,
    <include refid="Blob_Column_List" />
    from qxdomain
    where (eccode = #{0} and eccode!='')  or  domain_name= #{1}
  </select>  
  
  <select id="selectMaxPrimaryKey" resultType="java.lang.String">
    select max(domain)
    from qxdomain
  </select>
  
  <delete id="deleteByPrimaryKey" parameterType="java.lang.String">
    delete from qxdomain
    where domain = #{domain,jdbcType=VARCHAR}
  </delete>
  <insert id="insert" parameterType="com.cmccsi.entity.qxdomainDto" >
    insert into qxdomain (domain, domain_name, logo, 
      product_name, contact, com_site, 
      license, paramvalue, paramname, 
      corpinfovalue, corpinfoname, pointname, 
      pointvalue, status, urllist, 
      eccode, cyloginflag, com_describe
      )
    values (#{domain,jdbcType=VARCHAR}, #{domainName,jdbcType=VARCHAR}, #{logo,jdbcType=VARCHAR}, 
      #{productName,jdbcType=VARCHAR}, #{contact,jdbcType=VARCHAR}, #{comSite,jdbcType=VARCHAR}, 
      #{license,jdbcType=INTEGER}, #{paramvalue,jdbcType=VARCHAR}, #{paramname,jdbcType=VARCHAR}, 
      #{corpinfovalue,jdbcType=VARCHAR}, #{corpinfoname,jdbcType=VARCHAR}, #{pointname,jdbcType=VARCHAR}, 
      #{pointvalue,jdbcType=VARCHAR}, #{status,jdbcType=VARCHAR}, #{urllist,jdbcType=VARCHAR}, 
      #{eccode,jdbcType=VARCHAR}, #{cyloginflag,jdbcType=INTEGER}, #{comDescribe,jdbcType=LONGVARCHAR}
      )
  </insert>
  <insert id="insertSelective" parameterType="com.cmccsi.entity.qxdomainDto" >
    insert into qxdomain
    <trim prefix="(" suffix=")" suffixOverrides="," >
      <if test="domain != null" >
        domain,
      </if>
      <if test="domainName != null" >
        domain_name,
      </if>
      <if test="logo != null" >
        logo,
      </if>
      <if test="productName != null" >
        product_name,
      </if>
      <if test="contact != null" >
        contact,
      </if>
      <if test="comSite != null" >
        com_site,
      </if>
      <if test="license != null" >
        license,
      </if>
      <if test="paramvalue != null" >
        paramvalue,
      </if>
      <if test="paramname != null" >
        paramname,
      </if>
      <if test="corpinfovalue != null" >
        corpinfovalue,
      </if>
      <if test="corpinfoname != null" >
        corpinfoname,
      </if>
      <if test="pointname != null" >
        pointname,
      </if>
      <if test="pointvalue != null" >
        pointvalue,
      </if>
      <if test="status != null" >
        status,
      </if>
      <if test="urllist != null" >
        urllist,
      </if>
      <if test="eccode != null" >
        eccode,
      </if>
      <if test="cyloginflag != null" >
        cyloginflag,
      </if>
      <if test="comDescribe != null" >
        com_describe,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides="," >
      <if test="domain != null" >
        #{domain,jdbcType=VARCHAR},
      </if>
      <if test="domainName != null" >
        #{domainName,jdbcType=VARCHAR},
      </if>
      <if test="logo != null" >
        #{logo,jdbcType=VARCHAR},
      </if>
      <if test="productName != null" >
        #{productName,jdbcType=VARCHAR},
      </if>
      <if test="contact != null" >
        #{contact,jdbcType=VARCHAR},
      </if>
      <if test="comSite != null" >
        #{comSite,jdbcType=VARCHAR},
      </if>
      <if test="license != null" >
        #{license,jdbcType=INTEGER},
      </if>
      <if test="paramvalue != null" >
        #{paramvalue,jdbcType=VARCHAR},
      </if>
      <if test="paramname != null" >
        #{paramname,jdbcType=VARCHAR},
      </if>
      <if test="corpinfovalue != null" >
        #{corpinfovalue,jdbcType=VARCHAR},
      </if>
      <if test="corpinfoname != null" >
        #{corpinfoname,jdbcType=VARCHAR},
      </if>
      <if test="pointname != null" >
        #{pointname,jdbcType=VARCHAR},
      </if>
      <if test="pointvalue != null" >
        #{pointvalue,jdbcType=VARCHAR},
      </if>
      <if test="status != null" >
        #{status,jdbcType=VARCHAR},
      </if>
      <if test="urllist != null" >
        #{urllist,jdbcType=VARCHAR},
      </if>
      <if test="eccode != null" >
        #{eccode,jdbcType=VARCHAR},
      </if>
      <if test="cyloginflag != null" >
        #{cyloginflag,jdbcType=INTEGER},
      </if>
      <if test="comDescribe != null" >
        #{comDescribe,jdbcType=LONGVARCHAR},
      </if>
    </trim>
  </insert>
  <update id="updateByPrimaryKeySelective" parameterType="com.cmccsi.entity.qxdomainDto" >
    update qxdomain
    <set >
      <if test="domainName != null" >
        domain_name = #{domainName,jdbcType=VARCHAR},
      </if>
      <if test="logo != null" >
        logo = #{logo,jdbcType=VARCHAR},
      </if>
      <if test="productName != null" >
        product_name = #{productName,jdbcType=VARCHAR},
      </if>
      <if test="contact != null" >
        contact = #{contact,jdbcType=VARCHAR},
      </if>
      <if test="comSite != null" >
        com_site = #{comSite,jdbcType=VARCHAR},
      </if>
      <if test="license != null" >
        license = #{license,jdbcType=INTEGER},
      </if>
      <if test="paramvalue != null" >
        paramvalue = #{paramvalue,jdbcType=VARCHAR},
      </if>
      <if test="paramname != null" >
        paramname = #{paramname,jdbcType=VARCHAR},
      </if>
      <if test="corpinfovalue != null" >
        corpinfovalue = #{corpinfovalue,jdbcType=VARCHAR},
      </if>
      <if test="corpinfoname != null" >
        corpinfoname = #{corpinfoname,jdbcType=VARCHAR},
      </if>
      <if test="pointname != null" >
        pointname = #{pointname,jdbcType=VARCHAR},
      </if>
      <if test="pointvalue != null" >
        pointvalue = #{pointvalue,jdbcType=VARCHAR},
      </if>
      <if test="status != null" >
        status = #{status,jdbcType=VARCHAR},
      </if>
      <if test="urllist != null" >
        urllist = #{urllist,jdbcType=VARCHAR},
      </if>
      <if test="eccode != null" >
        eccode = #{eccode,jdbcType=VARCHAR},
      </if>
      <if test="cyloginflag != null" >
        cyloginflag = #{cyloginflag,jdbcType=INTEGER},
      </if>
      <if test="comDescribe != null" >
        com_describe = #{comDescribe,jdbcType=LONGVARCHAR},
      </if>
    </set>
    where domain = #{domain,jdbcType=VARCHAR}
  </update>
  <update id="updateByPrimaryKeyWithBLOBs" parameterType="com.cmccsi.entity.qxdomainDto" >
    update qxdomain
    set domain_name = #{domainName,jdbcType=VARCHAR},
      logo = #{logo,jdbcType=VARCHAR},
      product_name = #{productName,jdbcType=VARCHAR},
      contact = #{contact,jdbcType=VARCHAR},
      com_site = #{comSite,jdbcType=VARCHAR},
      license = #{license,jdbcType=INTEGER},
      paramvalue = #{paramvalue,jdbcType=VARCHAR},
      paramname = #{paramname,jdbcType=VARCHAR},
      corpinfovalue = #{corpinfovalue,jdbcType=VARCHAR},
      corpinfoname = #{corpinfoname,jdbcType=VARCHAR},
      pointname = #{pointname,jdbcType=VARCHAR},
      pointvalue = #{pointvalue,jdbcType=VARCHAR},
      status = #{status,jdbcType=VARCHAR},
      urllist = #{urllist,jdbcType=VARCHAR},
      eccode = #{eccode,jdbcType=VARCHAR},
      cyloginflag = #{cyloginflag,jdbcType=INTEGER},
      com_describe = #{comDescribe,jdbcType=LONGVARCHAR}
    where domain = #{domain,jdbcType=VARCHAR}
  </update>
  <update id="updateByPrimaryKey" parameterType="com.cmccsi.entity.qxdomainDto" >
    update qxdomain
    set domain_name = #{domainName,jdbcType=VARCHAR},
      logo = #{logo,jdbcType=VARCHAR},
      product_name = #{productName,jdbcType=VARCHAR},
      contact = #{contact,jdbcType=VARCHAR},
      com_site = #{comSite,jdbcType=VARCHAR},
      license = #{license,jdbcType=INTEGER},
      paramvalue = #{paramvalue,jdbcType=VARCHAR},
      paramname = #{paramname,jdbcType=VARCHAR},
      corpinfovalue = #{corpinfovalue,jdbcType=VARCHAR},
      corpinfoname = #{corpinfoname,jdbcType=VARCHAR},
      pointname = #{pointname,jdbcType=VARCHAR},
      pointvalue = #{pointvalue,jdbcType=VARCHAR},
      status = #{status,jdbcType=VARCHAR},
      urllist = #{urllist,jdbcType=VARCHAR},
      eccode = #{eccode,jdbcType=VARCHAR},
      cyloginflag = #{cyloginflag,jdbcType=INTEGER}
    where domain = #{domain,jdbcType=VARCHAR}
  </update>
</mapper>